Character numeric type:
Char, varchar, long varchar
Nchar, nvarchar, long nvarchar
-Compatible data types are implemented through domains: sysname (varchar (30), text (long varchar domain), ntext (long nvarchar domain), and XML (long
The stored procedure created in oracle is inconsistent with the syntax in sybase and SQL server.
The following example shows how to use stored procedures in different databases.
---------------------------
Oracle:
Create or replace function MY_FUNC
(
Q: Using sp_helpsegment, you can see the space usage of a segment, but there are all the tables and index information on the paragraph in the result, and for a field that has many tables, it's scary. Want to see directly concerned about the space
First, Win7 X64 System installation Sybase ODBC:1, Download the corresponding package to C:\system_odbc ( folder name itself, in the following registry content needs to use ), and then need to add the directory to the PATH environment variable ;2.
When you create a table or declare a local variable, you must use the Sybase system predefined type.
1. Character type
Char (n) VarChar (n)
2. Numeric type
Integer type--integer SmallInt TinyInt
Floating-point type--real float number[p,s]
A marketplace has been injected to obtain more than 500 million user information and more than 600 million merchant information.
User Data is leaked, and the mobile phone number of the ID card is exposed.
GET
MySQL Getting Started 1, Database Basics (Understanding) 1.1, Database Introduction 1.1.1, what is a database? What is the role of the database?The database is the warehouse that stores the data, its essence is a file system, the data is stored in
1 databases: Warehouses for managing and storing data2 Advantages of the database:① can store a large amount of data ② easy to retrieve ③ maintain data consistency, integrity ④ security, can be shared ⑤ through combinatorial analysis, can generate
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.